package com.example.demo.mapper;

import com.example.demo.entity.CrCustomer;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface orderMapper {

    @Select("select * from cr_customer where customerName like CONCAT('%',#{name},'%') and carNumber like CONCAT('%',#{car},'%')")
    List<CrCustomer> selectAll(@Param("name")String name,@Param("car")String car);

}
